package com.jcgyl.export.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TbpayinfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TbpayinfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andPidIsNull() {
            addCriterion("pid is null");
            return (Criteria) this;
        }

        public Criteria andPidIsNotNull() {
            addCriterion("pid is not null");
            return (Criteria) this;
        }

        public Criteria andPidEqualTo(Long value) {
            addCriterion("pid =", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotEqualTo(Long value) {
            addCriterion("pid <>", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidGreaterThan(Long value) {
            addCriterion("pid >", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidGreaterThanOrEqualTo(Long value) {
            addCriterion("pid >=", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidLessThan(Long value) {
            addCriterion("pid <", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidLessThanOrEqualTo(Long value) {
            addCriterion("pid <=", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidIn(List<Long> values) {
            addCriterion("pid in", values, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotIn(List<Long> values) {
            addCriterion("pid not in", values, "pid");
            return (Criteria) this;
        }

        public Criteria andPidBetween(Long value1, Long value2) {
            addCriterion("pid between", value1, value2, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotBetween(Long value1, Long value2) {
            addCriterion("pid not between", value1, value2, "pid");
            return (Criteria) this;
        }

        public Criteria andExpressnumberIsNull() {
            addCriterion("expressnumber is null");
            return (Criteria) this;
        }

        public Criteria andExpressnumberIsNotNull() {
            addCriterion("expressnumber is not null");
            return (Criteria) this;
        }

        public Criteria andExpressnumberEqualTo(String value) {
            addCriterion("expressnumber =", value, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberNotEqualTo(String value) {
            addCriterion("expressnumber <>", value, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberGreaterThan(String value) {
            addCriterion("expressnumber >", value, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberGreaterThanOrEqualTo(String value) {
            addCriterion("expressnumber >=", value, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberLessThan(String value) {
            addCriterion("expressnumber <", value, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberLessThanOrEqualTo(String value) {
            addCriterion("expressnumber <=", value, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberLike(String value) {
            addCriterion("expressnumber like", value, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberNotLike(String value) {
            addCriterion("expressnumber not like", value, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberIn(List<String> values) {
            addCriterion("expressnumber in", values, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberNotIn(List<String> values) {
            addCriterion("expressnumber not in", values, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberBetween(String value1, String value2) {
            addCriterion("expressnumber between", value1, value2, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andExpressnumberNotBetween(String value1, String value2) {
            addCriterion("expressnumber not between", value1, value2, "expressnumber");
            return (Criteria) this;
        }

        public Criteria andSeqnoIsNull() {
            addCriterion("seqno is null");
            return (Criteria) this;
        }

        public Criteria andSeqnoIsNotNull() {
            addCriterion("seqno is not null");
            return (Criteria) this;
        }

        public Criteria andSeqnoEqualTo(String value) {
            addCriterion("seqno =", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoNotEqualTo(String value) {
            addCriterion("seqno <>", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoGreaterThan(String value) {
            addCriterion("seqno >", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoGreaterThanOrEqualTo(String value) {
            addCriterion("seqno >=", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoLessThan(String value) {
            addCriterion("seqno <", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoLessThanOrEqualTo(String value) {
            addCriterion("seqno <=", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoLike(String value) {
            addCriterion("seqno like", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoNotLike(String value) {
            addCriterion("seqno not like", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoIn(List<String> values) {
            addCriterion("seqno in", values, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoNotIn(List<String> values) {
            addCriterion("seqno not in", values, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoBetween(String value1, String value2) {
            addCriterion("seqno between", value1, value2, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoNotBetween(String value1, String value2) {
            addCriterion("seqno not between", value1, value2, "seqno");
            return (Criteria) this;
        }

        public Criteria andGuidIsNull() {
            addCriterion("guid is null");
            return (Criteria) this;
        }

        public Criteria andGuidIsNotNull() {
            addCriterion("guid is not null");
            return (Criteria) this;
        }

        public Criteria andGuidEqualTo(String value) {
            addCriterion("guid =", value, "guid");
            return (Criteria) this;
        }

        public Criteria andGuidNotEqualTo(String value) {
            addCriterion("guid <>", value, "guid");
            return (Criteria) this;
        }

        public Criteria andGuidGreaterThan(String value) {
            addCriterion("guid >", value, "guid");
            return (Criteria) this;
        }

        public Criteria andGuidGreaterThanOrEqualTo(String value) {
            addCriterion("guid >=", value, "guid");
            return (Criteria) this;
        }

        public Criteria andGuidLessThan(String value) {
            addCriterion("guid <", value, "guid");
            return (Criteria) this;
        }

        public Criteria andGuidLessThanOrEqualTo(String value) {
            addCriterion("guid <=", value, "guid");
            return (Criteria) this;
        }

        public Criteria andGuidLike(String value) {
            addCriterion("guid like", value, "guid");
            return (Criteria) this;
        }

        public Criteria andGuidNotLike(String value) {
            addCriterion("guid not like", value, "guid");
            return (Criteria) this;
        }

        public Criteria andGuidIn(List<String> values) {
            addCriterion("guid in", values, "guid");
            return (Criteria) this;
        }

        public Criteria andGuidNotIn(List<String> values) {
            addCriterion("guid not in", values, "guid");
            return (Criteria) this;
        }

        public Criteria andGuidBetween(String value1, String value2) {
            addCriterion("guid between", value1, value2, "guid");
            return (Criteria) this;
        }

        public Criteria andGuidNotBetween(String value1, String value2) {
            addCriterion("guid not between", value1, value2, "guid");
            return (Criteria) this;
        }

        public Criteria andManagercustomscodeIsNull() {
            addCriterion("managercustomscode is null");
            return (Criteria) this;
        }

        public Criteria andManagercustomscodeIsNotNull() {
            addCriterion("managercustomscode is not null");
            return (Criteria) this;
        }

        public Criteria andManagercustomscodeEqualTo(String value) {
            addCriterion("managercustomscode =", value, "managercustomscode");
            return (Criteria) this;
        }

        public Criteria andManagercustomscodeNotEqualTo(String value) {
            addCriterion("managercustomscode <>", value, "managercustomscode");
            return (Criteria) this;
        }

        public Criteria andManagercustomscodeGreaterThan(String value) {
            addCriterion("managercustomscode >", value, "managercustomscode");
            return (Criteria) this;
        }

        public Criteria andManagercustomscodeGreaterThanOrEqualTo(String value) {
            addCriterion("managercustomscode >=", value, "managercustomscode");
            return (Criteria) this;
        }

        public Criteria andManagercustomscodeLessThan(String value) {
            addCriterion("managercustomscode <", value, "managercustomscode");
            return (Criteria) this;
        }

        public Criteria andManagercustomscodeLessThanOrEqualTo(String value) {
            addCriterion("managercustomscode <=", value, "managercustomscode");
            return (Criteria) this;
        }

        public Criteria andManagercustomscodeLike(String value) {
            addCriterion("managercustomscode like", value, "managercustomscode");
            return (Criteria) this;
        }

        public Criteria andManagercustomscodeNotLike(String value) {
            addCriterion("managercustomscode not like", value, "managercustomscode");
            return (Criteria) this;
        }

        public Criteria andManagercustomscodeIn(List<String> values) {
            addCriterion("managercustomscode in", values, "managercustomscode");
            return (Criteria) this;
        }

        public Criteria andManagercustomscodeNotIn(List<String> values) {
            addCriterion("managercustomscode not in", values, "managercustomscode");
            return (Criteria) this;
        }

        public Criteria andManagercustomscodeBetween(String value1, String value2) {
            addCriterion("managercustomscode between", value1, value2, "managercustomscode");
            return (Criteria) this;
        }

        public Criteria andManagercustomscodeNotBetween(String value1, String value2) {
            addCriterion("managercustomscode not between", value1, value2, "managercustomscode");
            return (Criteria) this;
        }

        public Criteria andBillmodeIsNull() {
            addCriterion("billmode is null");
            return (Criteria) this;
        }

        public Criteria andBillmodeIsNotNull() {
            addCriterion("billmode is not null");
            return (Criteria) this;
        }

        public Criteria andBillmodeEqualTo(String value) {
            addCriterion("billmode =", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotEqualTo(String value) {
            addCriterion("billmode <>", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeGreaterThan(String value) {
            addCriterion("billmode >", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeGreaterThanOrEqualTo(String value) {
            addCriterion("billmode >=", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeLessThan(String value) {
            addCriterion("billmode <", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeLessThanOrEqualTo(String value) {
            addCriterion("billmode <=", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeLike(String value) {
            addCriterion("billmode like", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotLike(String value) {
            addCriterion("billmode not like", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeIn(List<String> values) {
            addCriterion("billmode in", values, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotIn(List<String> values) {
            addCriterion("billmode not in", values, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeBetween(String value1, String value2) {
            addCriterion("billmode between", value1, value2, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotBetween(String value1, String value2) {
            addCriterion("billmode not between", value1, value2, "billmode");
            return (Criteria) this;
        }

        public Criteria andPaytimeIsNull() {
            addCriterion("paytime is null");
            return (Criteria) this;
        }

        public Criteria andPaytimeIsNotNull() {
            addCriterion("paytime is not null");
            return (Criteria) this;
        }

        public Criteria andPaytimeEqualTo(Date value) {
            addCriterion("paytime =", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotEqualTo(Date value) {
            addCriterion("paytime <>", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeGreaterThan(Date value) {
            addCriterion("paytime >", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeGreaterThanOrEqualTo(Date value) {
            addCriterion("paytime >=", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeLessThan(Date value) {
            addCriterion("paytime <", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeLessThanOrEqualTo(Date value) {
            addCriterion("paytime <=", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeIn(List<Date> values) {
            addCriterion("paytime in", values, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotIn(List<Date> values) {
            addCriterion("paytime not in", values, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeBetween(Date value1, Date value2) {
            addCriterion("paytime between", value1, value2, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotBetween(Date value1, Date value2) {
            addCriterion("paytime not between", value1, value2, "paytime");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeIsNull() {
            addCriterion("payenterprisecode is null");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeIsNotNull() {
            addCriterion("payenterprisecode is not null");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeEqualTo(String value) {
            addCriterion("payenterprisecode =", value, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeNotEqualTo(String value) {
            addCriterion("payenterprisecode <>", value, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeGreaterThan(String value) {
            addCriterion("payenterprisecode >", value, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeGreaterThanOrEqualTo(String value) {
            addCriterion("payenterprisecode >=", value, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeLessThan(String value) {
            addCriterion("payenterprisecode <", value, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeLessThanOrEqualTo(String value) {
            addCriterion("payenterprisecode <=", value, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeLike(String value) {
            addCriterion("payenterprisecode like", value, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeNotLike(String value) {
            addCriterion("payenterprisecode not like", value, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeIn(List<String> values) {
            addCriterion("payenterprisecode in", values, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeNotIn(List<String> values) {
            addCriterion("payenterprisecode not in", values, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeBetween(String value1, String value2) {
            addCriterion("payenterprisecode between", value1, value2, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisecodeNotBetween(String value1, String value2) {
            addCriterion("payenterprisecode not between", value1, value2, "payenterprisecode");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameIsNull() {
            addCriterion("payenterprisename is null");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameIsNotNull() {
            addCriterion("payenterprisename is not null");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameEqualTo(String value) {
            addCriterion("payenterprisename =", value, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameNotEqualTo(String value) {
            addCriterion("payenterprisename <>", value, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameGreaterThan(String value) {
            addCriterion("payenterprisename >", value, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameGreaterThanOrEqualTo(String value) {
            addCriterion("payenterprisename >=", value, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameLessThan(String value) {
            addCriterion("payenterprisename <", value, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameLessThanOrEqualTo(String value) {
            addCriterion("payenterprisename <=", value, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameLike(String value) {
            addCriterion("payenterprisename like", value, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameNotLike(String value) {
            addCriterion("payenterprisename not like", value, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameIn(List<String> values) {
            addCriterion("payenterprisename in", values, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameNotIn(List<String> values) {
            addCriterion("payenterprisename not in", values, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameBetween(String value1, String value2) {
            addCriterion("payenterprisename between", value1, value2, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPayenterprisenameNotBetween(String value1, String value2) {
            addCriterion("payenterprisename not between", value1, value2, "payenterprisename");
            return (Criteria) this;
        }

        public Criteria andPaynumberIsNull() {
            addCriterion("paynumber is null");
            return (Criteria) this;
        }

        public Criteria andPaynumberIsNotNull() {
            addCriterion("paynumber is not null");
            return (Criteria) this;
        }

        public Criteria andPaynumberEqualTo(String value) {
            addCriterion("paynumber =", value, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberNotEqualTo(String value) {
            addCriterion("paynumber <>", value, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberGreaterThan(String value) {
            addCriterion("paynumber >", value, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberGreaterThanOrEqualTo(String value) {
            addCriterion("paynumber >=", value, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberLessThan(String value) {
            addCriterion("paynumber <", value, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberLessThanOrEqualTo(String value) {
            addCriterion("paynumber <=", value, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberLike(String value) {
            addCriterion("paynumber like", value, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberNotLike(String value) {
            addCriterion("paynumber not like", value, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberIn(List<String> values) {
            addCriterion("paynumber in", values, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberNotIn(List<String> values) {
            addCriterion("paynumber not in", values, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberBetween(String value1, String value2) {
            addCriterion("paynumber between", value1, value2, "paynumber");
            return (Criteria) this;
        }

        public Criteria andPaynumberNotBetween(String value1, String value2) {
            addCriterion("paynumber not between", value1, value2, "paynumber");
            return (Criteria) this;
        }

        public Criteria andEcpcodeIsNull() {
            addCriterion("ecpcode is null");
            return (Criteria) this;
        }

        public Criteria andEcpcodeIsNotNull() {
            addCriterion("ecpcode is not null");
            return (Criteria) this;
        }

        public Criteria andEcpcodeEqualTo(String value) {
            addCriterion("ecpcode =", value, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeNotEqualTo(String value) {
            addCriterion("ecpcode <>", value, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeGreaterThan(String value) {
            addCriterion("ecpcode >", value, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ecpcode >=", value, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeLessThan(String value) {
            addCriterion("ecpcode <", value, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeLessThanOrEqualTo(String value) {
            addCriterion("ecpcode <=", value, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeLike(String value) {
            addCriterion("ecpcode like", value, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeNotLike(String value) {
            addCriterion("ecpcode not like", value, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeIn(List<String> values) {
            addCriterion("ecpcode in", values, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeNotIn(List<String> values) {
            addCriterion("ecpcode not in", values, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeBetween(String value1, String value2) {
            addCriterion("ecpcode between", value1, value2, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpcodeNotBetween(String value1, String value2) {
            addCriterion("ecpcode not between", value1, value2, "ecpcode");
            return (Criteria) this;
        }

        public Criteria andEcpnameIsNull() {
            addCriterion("ecpname is null");
            return (Criteria) this;
        }

        public Criteria andEcpnameIsNotNull() {
            addCriterion("ecpname is not null");
            return (Criteria) this;
        }

        public Criteria andEcpnameEqualTo(String value) {
            addCriterion("ecpname =", value, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameNotEqualTo(String value) {
            addCriterion("ecpname <>", value, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameGreaterThan(String value) {
            addCriterion("ecpname >", value, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameGreaterThanOrEqualTo(String value) {
            addCriterion("ecpname >=", value, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameLessThan(String value) {
            addCriterion("ecpname <", value, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameLessThanOrEqualTo(String value) {
            addCriterion("ecpname <=", value, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameLike(String value) {
            addCriterion("ecpname like", value, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameNotLike(String value) {
            addCriterion("ecpname not like", value, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameIn(List<String> values) {
            addCriterion("ecpname in", values, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameNotIn(List<String> values) {
            addCriterion("ecpname not in", values, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameBetween(String value1, String value2) {
            addCriterion("ecpname between", value1, value2, "ecpname");
            return (Criteria) this;
        }

        public Criteria andEcpnameNotBetween(String value1, String value2) {
            addCriterion("ecpname not between", value1, value2, "ecpname");
            return (Criteria) this;
        }

        public Criteria andPaymenttypeIsNull() {
            addCriterion("paymenttype is null");
            return (Criteria) this;
        }

        public Criteria andPaymenttypeIsNotNull() {
            addCriterion("paymenttype is not null");
            return (Criteria) this;
        }

        public Criteria andPaymenttypeEqualTo(String value) {
            addCriterion("paymenttype =", value, "paymenttype");
            return (Criteria) this;
        }

        public Criteria andPaymenttypeNotEqualTo(String value) {
            addCriterion("paymenttype <>", value, "paymenttype");
            return (Criteria) this;
        }

        public Criteria andPaymenttypeGreaterThan(String value) {
            addCriterion("paymenttype >", value, "paymenttype");
            return (Criteria) this;
        }

        public Criteria andPaymenttypeGreaterThanOrEqualTo(String value) {
            addCriterion("paymenttype >=", value, "paymenttype");
            return (Criteria) this;
        }

        public Criteria andPaymenttypeLessThan(String value) {
            addCriterion("paymenttype <", value, "paymenttype");
            return (Criteria) this;
        }

        public Criteria andPaymenttypeLessThanOrEqualTo(String value) {
            addCriterion("paymenttype <=", value, "paymenttype");
            return (Criteria) this;
        }

        public Criteria andPaymenttypeLike(String value) {
            addCriterion("paymenttype like", value, "paymenttype");
            return (Criteria) this;
        }

        public Criteria andPaymenttypeNotLike(String value) {
            addCriterion("paymenttype not like", value, "paymenttype");
            return (Criteria) this;
        }

        public Criteria andPaymenttypeIn(List<String> values) {
            addCriterion("paymenttype in", values, "paymenttype");
            return (Criteria) this;
        }

        public Criteria andPaymenttypeNotIn(List<String> values) {
            addCriterion("paymenttype not in", values, "paymenttype");
            return (Criteria) this;
        }

        public Criteria andPaymenttypeBetween(String value1, String value2) {
            addCriterion("paymenttype between", value1, value2, "paymenttype");
            return (Criteria) this;
        }

        public Criteria andPaymenttypeNotBetween(String value1, String value2) {
            addCriterion("paymenttype not between", value1, value2, "paymenttype");
            return (Criteria) this;
        }

        public Criteria andMonetarytypeIsNull() {
            addCriterion("monetarytype is null");
            return (Criteria) this;
        }

        public Criteria andMonetarytypeIsNotNull() {
            addCriterion("monetarytype is not null");
            return (Criteria) this;
        }

        public Criteria andMonetarytypeEqualTo(String value) {
            addCriterion("monetarytype =", value, "monetarytype");
            return (Criteria) this;
        }

        public Criteria andMonetarytypeNotEqualTo(String value) {
            addCriterion("monetarytype <>", value, "monetarytype");
            return (Criteria) this;
        }

        public Criteria andMonetarytypeGreaterThan(String value) {
            addCriterion("monetarytype >", value, "monetarytype");
            return (Criteria) this;
        }

        public Criteria andMonetarytypeGreaterThanOrEqualTo(String value) {
            addCriterion("monetarytype >=", value, "monetarytype");
            return (Criteria) this;
        }

        public Criteria andMonetarytypeLessThan(String value) {
            addCriterion("monetarytype <", value, "monetarytype");
            return (Criteria) this;
        }

        public Criteria andMonetarytypeLessThanOrEqualTo(String value) {
            addCriterion("monetarytype <=", value, "monetarytype");
            return (Criteria) this;
        }

        public Criteria andMonetarytypeLike(String value) {
            addCriterion("monetarytype like", value, "monetarytype");
            return (Criteria) this;
        }

        public Criteria andMonetarytypeNotLike(String value) {
            addCriterion("monetarytype not like", value, "monetarytype");
            return (Criteria) this;
        }

        public Criteria andMonetarytypeIn(List<String> values) {
            addCriterion("monetarytype in", values, "monetarytype");
            return (Criteria) this;
        }

        public Criteria andMonetarytypeNotIn(List<String> values) {
            addCriterion("monetarytype not in", values, "monetarytype");
            return (Criteria) this;
        }

        public Criteria andMonetarytypeBetween(String value1, String value2) {
            addCriterion("monetarytype between", value1, value2, "monetarytype");
            return (Criteria) this;
        }

        public Criteria andMonetarytypeNotBetween(String value1, String value2) {
            addCriterion("monetarytype not between", value1, value2, "monetarytype");
            return (Criteria) this;
        }

        public Criteria andFeeIsNull() {
            addCriterion("fee is null");
            return (Criteria) this;
        }

        public Criteria andFeeIsNotNull() {
            addCriterion("fee is not null");
            return (Criteria) this;
        }

        public Criteria andFeeEqualTo(BigDecimal value) {
            addCriterion("fee =", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotEqualTo(BigDecimal value) {
            addCriterion("fee <>", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeGreaterThan(BigDecimal value) {
            addCriterion("fee >", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fee >=", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeLessThan(BigDecimal value) {
            addCriterion("fee <", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fee <=", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeIn(List<BigDecimal> values) {
            addCriterion("fee in", values, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotIn(List<BigDecimal> values) {
            addCriterion("fee not in", values, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fee between", value1, value2, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fee not between", value1, value2, "fee");
            return (Criteria) this;
        }

        public Criteria andCustomerflagIsNull() {
            addCriterion("customerflag is null");
            return (Criteria) this;
        }

        public Criteria andCustomerflagIsNotNull() {
            addCriterion("customerflag is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerflagEqualTo(String value) {
            addCriterion("customerflag =", value, "customerflag");
            return (Criteria) this;
        }

        public Criteria andCustomerflagNotEqualTo(String value) {
            addCriterion("customerflag <>", value, "customerflag");
            return (Criteria) this;
        }

        public Criteria andCustomerflagGreaterThan(String value) {
            addCriterion("customerflag >", value, "customerflag");
            return (Criteria) this;
        }

        public Criteria andCustomerflagGreaterThanOrEqualTo(String value) {
            addCriterion("customerflag >=", value, "customerflag");
            return (Criteria) this;
        }

        public Criteria andCustomerflagLessThan(String value) {
            addCriterion("customerflag <", value, "customerflag");
            return (Criteria) this;
        }

        public Criteria andCustomerflagLessThanOrEqualTo(String value) {
            addCriterion("customerflag <=", value, "customerflag");
            return (Criteria) this;
        }

        public Criteria andCustomerflagLike(String value) {
            addCriterion("customerflag like", value, "customerflag");
            return (Criteria) this;
        }

        public Criteria andCustomerflagNotLike(String value) {
            addCriterion("customerflag not like", value, "customerflag");
            return (Criteria) this;
        }

        public Criteria andCustomerflagIn(List<String> values) {
            addCriterion("customerflag in", values, "customerflag");
            return (Criteria) this;
        }

        public Criteria andCustomerflagNotIn(List<String> values) {
            addCriterion("customerflag not in", values, "customerflag");
            return (Criteria) this;
        }

        public Criteria andCustomerflagBetween(String value1, String value2) {
            addCriterion("customerflag between", value1, value2, "customerflag");
            return (Criteria) this;
        }

        public Criteria andCustomerflagNotBetween(String value1, String value2) {
            addCriterion("customerflag not between", value1, value2, "customerflag");
            return (Criteria) this;
        }

        public Criteria andIdtypeIsNull() {
            addCriterion("idtype is null");
            return (Criteria) this;
        }

        public Criteria andIdtypeIsNotNull() {
            addCriterion("idtype is not null");
            return (Criteria) this;
        }

        public Criteria andIdtypeEqualTo(String value) {
            addCriterion("idtype =", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeNotEqualTo(String value) {
            addCriterion("idtype <>", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeGreaterThan(String value) {
            addCriterion("idtype >", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeGreaterThanOrEqualTo(String value) {
            addCriterion("idtype >=", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeLessThan(String value) {
            addCriterion("idtype <", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeLessThanOrEqualTo(String value) {
            addCriterion("idtype <=", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeLike(String value) {
            addCriterion("idtype like", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeNotLike(String value) {
            addCriterion("idtype not like", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeIn(List<String> values) {
            addCriterion("idtype in", values, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeNotIn(List<String> values) {
            addCriterion("idtype not in", values, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeBetween(String value1, String value2) {
            addCriterion("idtype between", value1, value2, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeNotBetween(String value1, String value2) {
            addCriterion("idtype not between", value1, value2, "idtype");
            return (Criteria) this;
        }

        public Criteria andCustomeridIsNull() {
            addCriterion("customerid is null");
            return (Criteria) this;
        }

        public Criteria andCustomeridIsNotNull() {
            addCriterion("customerid is not null");
            return (Criteria) this;
        }

        public Criteria andCustomeridEqualTo(String value) {
            addCriterion("customerid =", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridNotEqualTo(String value) {
            addCriterion("customerid <>", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridGreaterThan(String value) {
            addCriterion("customerid >", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridGreaterThanOrEqualTo(String value) {
            addCriterion("customerid >=", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridLessThan(String value) {
            addCriterion("customerid <", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridLessThanOrEqualTo(String value) {
            addCriterion("customerid <=", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridLike(String value) {
            addCriterion("customerid like", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridNotLike(String value) {
            addCriterion("customerid not like", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridIn(List<String> values) {
            addCriterion("customerid in", values, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridNotIn(List<String> values) {
            addCriterion("customerid not in", values, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridBetween(String value1, String value2) {
            addCriterion("customerid between", value1, value2, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridNotBetween(String value1, String value2) {
            addCriterion("customerid not between", value1, value2, "customerid");
            return (Criteria) this;
        }

        public Criteria andIetypeIsNull() {
            addCriterion("ietype is null");
            return (Criteria) this;
        }

        public Criteria andIetypeIsNotNull() {
            addCriterion("ietype is not null");
            return (Criteria) this;
        }

        public Criteria andIetypeEqualTo(String value) {
            addCriterion("ietype =", value, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeNotEqualTo(String value) {
            addCriterion("ietype <>", value, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeGreaterThan(String value) {
            addCriterion("ietype >", value, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeGreaterThanOrEqualTo(String value) {
            addCriterion("ietype >=", value, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeLessThan(String value) {
            addCriterion("ietype <", value, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeLessThanOrEqualTo(String value) {
            addCriterion("ietype <=", value, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeLike(String value) {
            addCriterion("ietype like", value, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeNotLike(String value) {
            addCriterion("ietype not like", value, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeIn(List<String> values) {
            addCriterion("ietype in", values, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeNotIn(List<String> values) {
            addCriterion("ietype not in", values, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeBetween(String value1, String value2) {
            addCriterion("ietype between", value1, value2, "ietype");
            return (Criteria) this;
        }

        public Criteria andIetypeNotBetween(String value1, String value2) {
            addCriterion("ietype not between", value1, value2, "ietype");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andPayuserIsNull() {
            addCriterion("payuser is null");
            return (Criteria) this;
        }

        public Criteria andPayuserIsNotNull() {
            addCriterion("payuser is not null");
            return (Criteria) this;
        }

        public Criteria andPayuserEqualTo(String value) {
            addCriterion("payuser =", value, "payuser");
            return (Criteria) this;
        }

        public Criteria andPayuserNotEqualTo(String value) {
            addCriterion("payuser <>", value, "payuser");
            return (Criteria) this;
        }

        public Criteria andPayuserGreaterThan(String value) {
            addCriterion("payuser >", value, "payuser");
            return (Criteria) this;
        }

        public Criteria andPayuserGreaterThanOrEqualTo(String value) {
            addCriterion("payuser >=", value, "payuser");
            return (Criteria) this;
        }

        public Criteria andPayuserLessThan(String value) {
            addCriterion("payuser <", value, "payuser");
            return (Criteria) this;
        }

        public Criteria andPayuserLessThanOrEqualTo(String value) {
            addCriterion("payuser <=", value, "payuser");
            return (Criteria) this;
        }

        public Criteria andPayuserLike(String value) {
            addCriterion("payuser like", value, "payuser");
            return (Criteria) this;
        }

        public Criteria andPayuserNotLike(String value) {
            addCriterion("payuser not like", value, "payuser");
            return (Criteria) this;
        }

        public Criteria andPayuserIn(List<String> values) {
            addCriterion("payuser in", values, "payuser");
            return (Criteria) this;
        }

        public Criteria andPayuserNotIn(List<String> values) {
            addCriterion("payuser not in", values, "payuser");
            return (Criteria) this;
        }

        public Criteria andPayuserBetween(String value1, String value2) {
            addCriterion("payuser between", value1, value2, "payuser");
            return (Criteria) this;
        }

        public Criteria andPayuserNotBetween(String value1, String value2) {
            addCriterion("payuser not between", value1, value2, "payuser");
            return (Criteria) this;
        }

        public Criteria andPayecodeIsNull() {
            addCriterion("payecode is null");
            return (Criteria) this;
        }

        public Criteria andPayecodeIsNotNull() {
            addCriterion("payecode is not null");
            return (Criteria) this;
        }

        public Criteria andPayecodeEqualTo(String value) {
            addCriterion("payecode =", value, "payecode");
            return (Criteria) this;
        }

        public Criteria andPayecodeNotEqualTo(String value) {
            addCriterion("payecode <>", value, "payecode");
            return (Criteria) this;
        }

        public Criteria andPayecodeGreaterThan(String value) {
            addCriterion("payecode >", value, "payecode");
            return (Criteria) this;
        }

        public Criteria andPayecodeGreaterThanOrEqualTo(String value) {
            addCriterion("payecode >=", value, "payecode");
            return (Criteria) this;
        }

        public Criteria andPayecodeLessThan(String value) {
            addCriterion("payecode <", value, "payecode");
            return (Criteria) this;
        }

        public Criteria andPayecodeLessThanOrEqualTo(String value) {
            addCriterion("payecode <=", value, "payecode");
            return (Criteria) this;
        }

        public Criteria andPayecodeLike(String value) {
            addCriterion("payecode like", value, "payecode");
            return (Criteria) this;
        }

        public Criteria andPayecodeNotLike(String value) {
            addCriterion("payecode not like", value, "payecode");
            return (Criteria) this;
        }

        public Criteria andPayecodeIn(List<String> values) {
            addCriterion("payecode in", values, "payecode");
            return (Criteria) this;
        }

        public Criteria andPayecodeNotIn(List<String> values) {
            addCriterion("payecode not in", values, "payecode");
            return (Criteria) this;
        }

        public Criteria andPayecodeBetween(String value1, String value2) {
            addCriterion("payecode between", value1, value2, "payecode");
            return (Criteria) this;
        }

        public Criteria andPayecodeNotBetween(String value1, String value2) {
            addCriterion("payecode not between", value1, value2, "payecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspIsNull() {
            addCriterion("cbecodeinsp is null");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspIsNotNull() {
            addCriterion("cbecodeinsp is not null");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspEqualTo(String value) {
            addCriterion("cbecodeinsp =", value, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspNotEqualTo(String value) {
            addCriterion("cbecodeinsp <>", value, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspGreaterThan(String value) {
            addCriterion("cbecodeinsp >", value, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspGreaterThanOrEqualTo(String value) {
            addCriterion("cbecodeinsp >=", value, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspLessThan(String value) {
            addCriterion("cbecodeinsp <", value, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspLessThanOrEqualTo(String value) {
            addCriterion("cbecodeinsp <=", value, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspLike(String value) {
            addCriterion("cbecodeinsp like", value, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspNotLike(String value) {
            addCriterion("cbecodeinsp not like", value, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspIn(List<String> values) {
            addCriterion("cbecodeinsp in", values, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspNotIn(List<String> values) {
            addCriterion("cbecodeinsp not in", values, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspBetween(String value1, String value2) {
            addCriterion("cbecodeinsp between", value1, value2, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeinspNotBetween(String value1, String value2) {
            addCriterion("cbecodeinsp not between", value1, value2, "cbecodeinsp");
            return (Criteria) this;
        }

        public Criteria andCoininspIsNull() {
            addCriterion("coininsp is null");
            return (Criteria) this;
        }

        public Criteria andCoininspIsNotNull() {
            addCriterion("coininsp is not null");
            return (Criteria) this;
        }

        public Criteria andCoininspEqualTo(String value) {
            addCriterion("coininsp =", value, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspNotEqualTo(String value) {
            addCriterion("coininsp <>", value, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspGreaterThan(String value) {
            addCriterion("coininsp >", value, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspGreaterThanOrEqualTo(String value) {
            addCriterion("coininsp >=", value, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspLessThan(String value) {
            addCriterion("coininsp <", value, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspLessThanOrEqualTo(String value) {
            addCriterion("coininsp <=", value, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspLike(String value) {
            addCriterion("coininsp like", value, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspNotLike(String value) {
            addCriterion("coininsp not like", value, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspIn(List<String> values) {
            addCriterion("coininsp in", values, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspNotIn(List<String> values) {
            addCriterion("coininsp not in", values, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspBetween(String value1, String value2) {
            addCriterion("coininsp between", value1, value2, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCoininspNotBetween(String value1, String value2) {
            addCriterion("coininsp not between", value1, value2, "coininsp");
            return (Criteria) this;
        }

        public Criteria andCbecodeIsNull() {
            addCriterion("cbecode is null");
            return (Criteria) this;
        }

        public Criteria andCbecodeIsNotNull() {
            addCriterion("cbecode is not null");
            return (Criteria) this;
        }

        public Criteria andCbecodeEqualTo(String value) {
            addCriterion("cbecode =", value, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeNotEqualTo(String value) {
            addCriterion("cbecode <>", value, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeGreaterThan(String value) {
            addCriterion("cbecode >", value, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeGreaterThanOrEqualTo(String value) {
            addCriterion("cbecode >=", value, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeLessThan(String value) {
            addCriterion("cbecode <", value, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeLessThanOrEqualTo(String value) {
            addCriterion("cbecode <=", value, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeLike(String value) {
            addCriterion("cbecode like", value, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeNotLike(String value) {
            addCriterion("cbecode not like", value, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeIn(List<String> values) {
            addCriterion("cbecode in", values, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeNotIn(List<String> values) {
            addCriterion("cbecode not in", values, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeBetween(String value1, String value2) {
            addCriterion("cbecode between", value1, value2, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbecodeNotBetween(String value1, String value2) {
            addCriterion("cbecode not between", value1, value2, "cbecode");
            return (Criteria) this;
        }

        public Criteria andCbenameIsNull() {
            addCriterion("cbename is null");
            return (Criteria) this;
        }

        public Criteria andCbenameIsNotNull() {
            addCriterion("cbename is not null");
            return (Criteria) this;
        }

        public Criteria andCbenameEqualTo(String value) {
            addCriterion("cbename =", value, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameNotEqualTo(String value) {
            addCriterion("cbename <>", value, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameGreaterThan(String value) {
            addCriterion("cbename >", value, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameGreaterThanOrEqualTo(String value) {
            addCriterion("cbename >=", value, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameLessThan(String value) {
            addCriterion("cbename <", value, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameLessThanOrEqualTo(String value) {
            addCriterion("cbename <=", value, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameLike(String value) {
            addCriterion("cbename like", value, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameNotLike(String value) {
            addCriterion("cbename not like", value, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameIn(List<String> values) {
            addCriterion("cbename in", values, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameNotIn(List<String> values) {
            addCriterion("cbename not in", values, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameBetween(String value1, String value2) {
            addCriterion("cbename between", value1, value2, "cbename");
            return (Criteria) this;
        }

        public Criteria andCbenameNotBetween(String value1, String value2) {
            addCriterion("cbename not between", value1, value2, "cbename");
            return (Criteria) this;
        }

        public Criteria andModifymarkIsNull() {
            addCriterion("modifymark is null");
            return (Criteria) this;
        }

        public Criteria andModifymarkIsNotNull() {
            addCriterion("modifymark is not null");
            return (Criteria) this;
        }

        public Criteria andModifymarkEqualTo(String value) {
            addCriterion("modifymark =", value, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkNotEqualTo(String value) {
            addCriterion("modifymark <>", value, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkGreaterThan(String value) {
            addCriterion("modifymark >", value, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkGreaterThanOrEqualTo(String value) {
            addCriterion("modifymark >=", value, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkLessThan(String value) {
            addCriterion("modifymark <", value, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkLessThanOrEqualTo(String value) {
            addCriterion("modifymark <=", value, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkLike(String value) {
            addCriterion("modifymark like", value, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkNotLike(String value) {
            addCriterion("modifymark not like", value, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkIn(List<String> values) {
            addCriterion("modifymark in", values, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkNotIn(List<String> values) {
            addCriterion("modifymark not in", values, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkBetween(String value1, String value2) {
            addCriterion("modifymark between", value1, value2, "modifymark");
            return (Criteria) this;
        }

        public Criteria andModifymarkNotBetween(String value1, String value2) {
            addCriterion("modifymark not between", value1, value2, "modifymark");
            return (Criteria) this;
        }

        public Criteria andKeyidIsNull() {
            addCriterion("keyid is null");
            return (Criteria) this;
        }

        public Criteria andKeyidIsNotNull() {
            addCriterion("keyid is not null");
            return (Criteria) this;
        }

        public Criteria andKeyidEqualTo(String value) {
            addCriterion("keyid =", value, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidNotEqualTo(String value) {
            addCriterion("keyid <>", value, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidGreaterThan(String value) {
            addCriterion("keyid >", value, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidGreaterThanOrEqualTo(String value) {
            addCriterion("keyid >=", value, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidLessThan(String value) {
            addCriterion("keyid <", value, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidLessThanOrEqualTo(String value) {
            addCriterion("keyid <=", value, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidLike(String value) {
            addCriterion("keyid like", value, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidNotLike(String value) {
            addCriterion("keyid not like", value, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidIn(List<String> values) {
            addCriterion("keyid in", values, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidNotIn(List<String> values) {
            addCriterion("keyid not in", values, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidBetween(String value1, String value2) {
            addCriterion("keyid between", value1, value2, "keyid");
            return (Criteria) this;
        }

        public Criteria andKeyidNotBetween(String value1, String value2) {
            addCriterion("keyid not between", value1, value2, "keyid");
            return (Criteria) this;
        }

        public Criteria andPaystatusIsNull() {
            addCriterion("paystatus is null");
            return (Criteria) this;
        }

        public Criteria andPaystatusIsNotNull() {
            addCriterion("paystatus is not null");
            return (Criteria) this;
        }

        public Criteria andPaystatusEqualTo(String value) {
            addCriterion("paystatus =", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusNotEqualTo(String value) {
            addCriterion("paystatus <>", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusGreaterThan(String value) {
            addCriterion("paystatus >", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusGreaterThanOrEqualTo(String value) {
            addCriterion("paystatus >=", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusLessThan(String value) {
            addCriterion("paystatus <", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusLessThanOrEqualTo(String value) {
            addCriterion("paystatus <=", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusLike(String value) {
            addCriterion("paystatus like", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusNotLike(String value) {
            addCriterion("paystatus not like", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusIn(List<String> values) {
            addCriterion("paystatus in", values, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusNotIn(List<String> values) {
            addCriterion("paystatus not in", values, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusBetween(String value1, String value2) {
            addCriterion("paystatus between", value1, value2, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusNotBetween(String value1, String value2) {
            addCriterion("paystatus not between", value1, value2, "paystatus");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidIsNull() {
            addCriterion("goodsbasicid is null");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidIsNotNull() {
            addCriterion("goodsbasicid is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidEqualTo(String value) {
            addCriterion("goodsbasicid =", value, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidNotEqualTo(String value) {
            addCriterion("goodsbasicid <>", value, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidGreaterThan(String value) {
            addCriterion("goodsbasicid >", value, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidGreaterThanOrEqualTo(String value) {
            addCriterion("goodsbasicid >=", value, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidLessThan(String value) {
            addCriterion("goodsbasicid <", value, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidLessThanOrEqualTo(String value) {
            addCriterion("goodsbasicid <=", value, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidLike(String value) {
            addCriterion("goodsbasicid like", value, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidNotLike(String value) {
            addCriterion("goodsbasicid not like", value, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidIn(List<String> values) {
            addCriterion("goodsbasicid in", values, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidNotIn(List<String> values) {
            addCriterion("goodsbasicid not in", values, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidBetween(String value1, String value2) {
            addCriterion("goodsbasicid between", value1, value2, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andGoodsbasicidNotBetween(String value1, String value2) {
            addCriterion("goodsbasicid not between", value1, value2, "goodsbasicid");
            return (Criteria) this;
        }

        public Criteria andSendstatusIsNull() {
            addCriterion("sendstatus is null");
            return (Criteria) this;
        }

        public Criteria andSendstatusIsNotNull() {
            addCriterion("sendstatus is not null");
            return (Criteria) this;
        }

        public Criteria andSendstatusEqualTo(String value) {
            addCriterion("sendstatus =", value, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusNotEqualTo(String value) {
            addCriterion("sendstatus <>", value, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusGreaterThan(String value) {
            addCriterion("sendstatus >", value, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusGreaterThanOrEqualTo(String value) {
            addCriterion("sendstatus >=", value, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusLessThan(String value) {
            addCriterion("sendstatus <", value, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusLessThanOrEqualTo(String value) {
            addCriterion("sendstatus <=", value, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusLike(String value) {
            addCriterion("sendstatus like", value, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusNotLike(String value) {
            addCriterion("sendstatus not like", value, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusIn(List<String> values) {
            addCriterion("sendstatus in", values, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusNotIn(List<String> values) {
            addCriterion("sendstatus not in", values, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusBetween(String value1, String value2) {
            addCriterion("sendstatus between", value1, value2, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSendstatusNotBetween(String value1, String value2) {
            addCriterion("sendstatus not between", value1, value2, "sendstatus");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonIsNull() {
            addCriterion("senderrorreason is null");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonIsNotNull() {
            addCriterion("senderrorreason is not null");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonEqualTo(String value) {
            addCriterion("senderrorreason =", value, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonNotEqualTo(String value) {
            addCriterion("senderrorreason <>", value, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonGreaterThan(String value) {
            addCriterion("senderrorreason >", value, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonGreaterThanOrEqualTo(String value) {
            addCriterion("senderrorreason >=", value, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonLessThan(String value) {
            addCriterion("senderrorreason <", value, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonLessThanOrEqualTo(String value) {
            addCriterion("senderrorreason <=", value, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonLike(String value) {
            addCriterion("senderrorreason like", value, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonNotLike(String value) {
            addCriterion("senderrorreason not like", value, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonIn(List<String> values) {
            addCriterion("senderrorreason in", values, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonNotIn(List<String> values) {
            addCriterion("senderrorreason not in", values, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonBetween(String value1, String value2) {
            addCriterion("senderrorreason between", value1, value2, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andSenderrorreasonNotBetween(String value1, String value2) {
            addCriterion("senderrorreason not between", value1, value2, "senderrorreason");
            return (Criteria) this;
        }

        public Criteria andAddtimeIsNull() {
            addCriterion("addtime is null");
            return (Criteria) this;
        }

        public Criteria andAddtimeIsNotNull() {
            addCriterion("addtime is not null");
            return (Criteria) this;
        }

        public Criteria andAddtimeEqualTo(Date value) {
            addCriterion("addtime =", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeNotEqualTo(Date value) {
            addCriterion("addtime <>", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeGreaterThan(Date value) {
            addCriterion("addtime >", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("addtime >=", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeLessThan(Date value) {
            addCriterion("addtime <", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeLessThanOrEqualTo(Date value) {
            addCriterion("addtime <=", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeIn(List<Date> values) {
            addCriterion("addtime in", values, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeNotIn(List<Date> values) {
            addCriterion("addtime not in", values, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeBetween(Date value1, Date value2) {
            addCriterion("addtime between", value1, value2, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeNotBetween(Date value1, Date value2) {
            addCriterion("addtime not between", value1, value2, "addtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeIsNull() {
            addCriterion("sendtime is null");
            return (Criteria) this;
        }

        public Criteria andSendtimeIsNotNull() {
            addCriterion("sendtime is not null");
            return (Criteria) this;
        }

        public Criteria andSendtimeEqualTo(Date value) {
            addCriterion("sendtime =", value, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeNotEqualTo(Date value) {
            addCriterion("sendtime <>", value, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeGreaterThan(Date value) {
            addCriterion("sendtime >", value, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("sendtime >=", value, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeLessThan(Date value) {
            addCriterion("sendtime <", value, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeLessThanOrEqualTo(Date value) {
            addCriterion("sendtime <=", value, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeIn(List<Date> values) {
            addCriterion("sendtime in", values, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeNotIn(List<Date> values) {
            addCriterion("sendtime not in", values, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeBetween(Date value1, Date value2) {
            addCriterion("sendtime between", value1, value2, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeNotBetween(Date value1, Date value2) {
            addCriterion("sendtime not between", value1, value2, "sendtime");
            return (Criteria) this;
        }

        public Criteria andOrderidIsNull() {
            addCriterion("orderid is null");
            return (Criteria) this;
        }

        public Criteria andOrderidIsNotNull() {
            addCriterion("orderid is not null");
            return (Criteria) this;
        }

        public Criteria andOrderidEqualTo(String value) {
            addCriterion("orderid =", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotEqualTo(String value) {
            addCriterion("orderid <>", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidGreaterThan(String value) {
            addCriterion("orderid >", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidGreaterThanOrEqualTo(String value) {
            addCriterion("orderid >=", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLessThan(String value) {
            addCriterion("orderid <", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLessThanOrEqualTo(String value) {
            addCriterion("orderid <=", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLike(String value) {
            addCriterion("orderid like", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotLike(String value) {
            addCriterion("orderid not like", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidIn(List<String> values) {
            addCriterion("orderid in", values, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotIn(List<String> values) {
            addCriterion("orderid not in", values, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidBetween(String value1, String value2) {
            addCriterion("orderid between", value1, value2, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotBetween(String value1, String value2) {
            addCriterion("orderid not between", value1, value2, "orderid");
            return (Criteria) this;
        }

        public Criteria andUploadidIsNull() {
            addCriterion("uploadid is null");
            return (Criteria) this;
        }

        public Criteria andUploadidIsNotNull() {
            addCriterion("uploadid is not null");
            return (Criteria) this;
        }

        public Criteria andUploadidEqualTo(Integer value) {
            addCriterion("uploadid =", value, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidNotEqualTo(Integer value) {
            addCriterion("uploadid <>", value, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidGreaterThan(Integer value) {
            addCriterion("uploadid >", value, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidGreaterThanOrEqualTo(Integer value) {
            addCriterion("uploadid >=", value, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidLessThan(Integer value) {
            addCriterion("uploadid <", value, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidLessThanOrEqualTo(Integer value) {
            addCriterion("uploadid <=", value, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidIn(List<Integer> values) {
            addCriterion("uploadid in", values, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidNotIn(List<Integer> values) {
            addCriterion("uploadid not in", values, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidBetween(Integer value1, Integer value2) {
            addCriterion("uploadid between", value1, value2, "uploadid");
            return (Criteria) this;
        }

        public Criteria andUploadidNotBetween(Integer value1, Integer value2) {
            addCriterion("uploadid not between", value1, value2, "uploadid");
            return (Criteria) this;
        }

        public Criteria andInspCbeCodeIsNull() {
            addCriterion("insp_cbe_code is null");
            return (Criteria) this;
        }

        public Criteria andInspCbeCodeIsNotNull() {
            addCriterion("insp_cbe_code is not null");
            return (Criteria) this;
        }

        public Criteria andInspCbeCodeEqualTo(String value) {
            addCriterion("insp_cbe_code =", value, "inspCbeCode");
            return (Criteria) this;
        }

        public Criteria andInspCbeCodeNotEqualTo(String value) {
            addCriterion("insp_cbe_code <>", value, "inspCbeCode");
            return (Criteria) this;
        }

        public Criteria andInspCbeCodeGreaterThan(String value) {
            addCriterion("insp_cbe_code >", value, "inspCbeCode");
            return (Criteria) this;
        }

        public Criteria andInspCbeCodeGreaterThanOrEqualTo(String value) {
            addCriterion("insp_cbe_code >=", value, "inspCbeCode");
            return (Criteria) this;
        }

        public Criteria andInspCbeCodeLessThan(String value) {
            addCriterion("insp_cbe_code <", value, "inspCbeCode");
            return (Criteria) this;
        }

        public Criteria andInspCbeCodeLessThanOrEqualTo(String value) {
            addCriterion("insp_cbe_code <=", value, "inspCbeCode");
            return (Criteria) this;
        }

        public Criteria andInspCbeCodeLike(String value) {
            addCriterion("insp_cbe_code like", value, "inspCbeCode");
            return (Criteria) this;
        }

        public Criteria andInspCbeCodeNotLike(String value) {
            addCriterion("insp_cbe_code not like", value, "inspCbeCode");
            return (Criteria) this;
        }

        public Criteria andInspCbeCodeIn(List<String> values) {
            addCriterion("insp_cbe_code in", values, "inspCbeCode");
            return (Criteria) this;
        }

        public Criteria andInspCbeCodeNotIn(List<String> values) {
            addCriterion("insp_cbe_code not in", values, "inspCbeCode");
            return (Criteria) this;
        }

        public Criteria andInspCbeCodeBetween(String value1, String value2) {
            addCriterion("insp_cbe_code between", value1, value2, "inspCbeCode");
            return (Criteria) this;
        }

        public Criteria andInspCbeCodeNotBetween(String value1, String value2) {
            addCriterion("insp_cbe_code not between", value1, value2, "inspCbeCode");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}